MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Object Name = 798

View and edit SQL

Suggested facets: Is Public Domain, Department, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, City

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
6960 69.94.5 0 0 7430 American Decorative Arts 1 Sherry glass 798 Sherry Glass American 1         Maker 1   Libbey Glass Company American, Toledo, Ohio, 1888–present   Libbey Glass Company  363 American 1 1888 2050 1904 1904 1904 Cut and engraved glass 558 H. 3 7/8 in. (9.8 cm); Diam. 2 1/2 in. (6.4 cm) Gift of Toledo Museum of Art and Owens-Illinois Inc., 1969 Made in 1 Toledo 96     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
6961 46.140.503 0 1 7431 American Decorative Arts 1 Sherry glass 798 Sherry Glass American 1         Maker 1 Probably Hobbs, Brockunier and Company 1863–1891   Hobbs, Brockunier and Company  162   1863 1891 ca. 1885–87 1882 1887 Blown glass 168 H. 4 3/4 in. (12.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 Wheeling 69     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
6962 46.140.504 0 1 7432 American Decorative Arts 1 Sherry glass 798 Sherry Glass American 1         Maker 1 Probably Hobbs, Brockunier and Company 1863–1891   Hobbs, Brockunier and Company  162   1863 1891 ca. 1885–87 1882 1887 Blown glass 168 H. 4 3/4 in. (12.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 Wheeling 69     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
6963 46.140.527 0 1 7433 American Decorative Arts 1 Sherry glass 798 Sherry Glass American 1         Maker 1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 ca. 1888 1885 1888 Blown glass 168 H. 4 3/8 in. (11.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 East Cambridge 6     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
6964 46.140.528 0 1 7434 American Decorative Arts 1 Sherry glass 798 Sherry Glass American 1         Maker 1 Probably New England Glass Company American, East Cambridge, Massachusetts, 1818–1888   New England Glass Company  10   1818 1888 ca. 1888 1885 1888 Blown glass 168 H. 4 3/8 in. (11.1 cm) Gift of Mrs. Emily Winthrop Miles, 1946 Made in 1 East Cambridge 6     United States 3             Glass 3   Metropolitan Museum of Art, New York, NY 1
334700 1980.373.4 0 0 482130 Modern and Contemporary Art 4 Sherry glass 798 Sherry glass           Designer|Manufacturer 3   Unknown Designer|Wiener Werkstätte     Unknown Designer|Wiener Werkstätte 45159       ca. 1915–25 1915 1925 Painted glass 199 H. 3-1/4 inches (8.3 cm.) Anonymous Gift, in honor of Mrs. Harold Bonwit, 1980                       Glass 3   Metropolitan Museum of Art, New York, NY 1
335557 1984.217.3 0 0 483059 Modern and Contemporary Art 4 Sherry glass 798 "Narciso" Sherry Glass           Designer|Manufacturer 3   Isabel Giampietro Knoll|Royal Leerdam Glass American (born Italy), Marsicovetere 1917–2010 New York|Dutch   Knoll, Isabel Giampietro|ROYAL LEERDAM 45418 American|Dutch 50 1917 2010 1956 1956 1956 Glass 31 H. 7, D(1). 1-3/4, D(2). 2-5/8 inches (17.8 x 4.4 x 6.7 cm.) Purchase, Theodore R. Gamble Jr. Gift, in honor of his mother, Mrs. Theodore Robert Gamble, 1984                       Glass 3   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 223.152ms · Data license: CC0 · Data source: metmuseum/openaccess